SELECT events.*, eventToShluchaAndDate.* FROM events
LEFT JOIN eventToShluchaAndDate ON events.eventID = eventToShluchaAndDate.eventToShluchEventID
WHERE events.mercazAllId=98 AND eventID=37803
AND eventToShluchFromTime != '00:00:00' AND eventToShluchToTime != '00:00:00'